Make a Planning Tool in Microsoft Excel by Tommy Axelsson

Author:Tommy Axelsson [Axelsson, Tommy]
Language: eng
Format: azw3
Published: 2017-08-19T04:00:00+00:00

Step 5 Design

Let’s make the planer a little more stylish!

See the title in cell “B1”? Let’s make the font a size of 28 and color the background of “A1:BN5” with a green of (Red:34, Green:116, Blue: 71) (or any other color you want). And while we have “A1:BN5” selected let’s change the font color too. Let’s make it white.

Now select cells “B1 to F5” and merge the cells.

To get a little flavor lets copy in the Excel logo (or your own company logo).

We can also add some borders for your Table from “A6:BN100”. I used a light green. I also like to make the border between column “F” and “G” a little thicker to divide the information part and the table part.

Now select “A5:F5” and go to tab “Data” and select “Filter”. This will create filters for all our columns. I normally add more columns like project, responsible and other stuff suited for what I use the planner for. You can easily add columns without messing stuff up by right click on a column from A to F and add a column. The filters we just made will make it easy to filter our table depending on what we want to see. For example:

Only priority “1” Actions/Tasks

Only one or more tasks in a particular status (for example “in progress” or “not planed”)

A particular project

Deadlines in ascending order

And much more

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.